import os

from openpyxl import Workbook

filename = 'data2.xlsx'
if os.path.exists(filename):
    os.remove(filename)

wb = Workbook()
ws = wb.create_sheet('sheet')

label = ['a', 'b']
base = ['base', 2048]
content = [100, 200]
for i in range(1, 49):
    label.append('E' + str(i))
    content.append(i)
    base.append(0)
print(label)
print(content)

# label = np.array(label)
# content = np.array(content)
ws.append(label)
ws.append(content)
ws.append(base)
wb.save(filename)
wb.close()
